Dashboard 03 - Creating Total Police Incidents by Time of Day Map 22


Step 1:  Create a Total Police Incidents by Time of Day Map

To get you started, use the previous map as a template.  Click on the YOY Crimes Map, press Ctrl+C to copy and Ctrl+V to paste it. 

From the copied map, set up as follows.


In Power BI Desktop, click on the page,  RaleighPoliceIncidents-Street

Visualizations

Click the Map  icon

Fields

Select the following:

A_KeyMeasures ->  .Total_Case_Numbers - Under Visualizations, drag & drop it in the Size section.

A_KeyMeasures ->  Latitude - Under Visualizations, drag & drop it in the Latitude section.

A_KeyMeasures ->  Longitude - Under Visualizations, drag & drop it in the Longitude section.

A_KeyMeasures ->  Time_Of_Day - Under Visualizations, drag & drop it in the Legend section.


Fields tab

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the fields as follows:

.Total_Case_Numbers = Total Police Incidents

Latitude = Latitude

Longitude = Longitude

Time_Of_Day = Time of Day


Note:  Total_Case_Numbers needs to be in the Size Section






Visualizations


Format tab

Under Format ->  General: X Position = 605 , Y Position = 156 , Width = 795 , Height = 817

Under Format -> Legend ->  Set it to ON , Position = Top Center , Title = OFF , Color = 000000 , Font Family = Segoe UI , Text Size = 11 pt

Under Format ->  Data Colors -> Afternoon = F0E199 , Late Night = 41A4FF , Morning = EB895F , Night = 717BC5

Under Format ->  Category ->  Set it to OFF

Under Format ->  Bubbles ->  Size = 10

Under Format -> Map Controls ->  Auto Zoom = ON , Zoom Buttons = ON

Under Format -> Title ->  Set it to ON , Title Text = Total Police Incidents by Time of Day , Font Color = 094780 , Background Color = E6E6E6 , Alignment = Center , Text Size = 17 pt , Font Family = DIN (Default)

Under Format ->  Background ->  Set it to ON , Color = FFFFFF

Under Format ->  Border ->  Set it to ON , Color = 666666





Step 2 - Add filter(s)

Filters

On the map, if there is any location(s) outside the Raleigh area, right-click on it and select Exclude all of them.



When finished, save project.


Tips and Tricks for Maps in Power BI